import pymysql

conn = pymysql.connect(host="localhost",port=3306,user='root',password='yangsu87852554',db='sys')
cur = conn.cursor()
cur.execute('select * from user')
# print(cur.fetchone())
# print(type(cur.fetchone()))
# print(type(cur.fetchall()))
# for item in cur.fetchall():
#     print(item[0],item[1])

data = cur.fetchall()
cur.close()
conn.close()

print(data)